dynamic hashing meaning in English
动态散列
Examples
- The optimizer will choose dynamic hash join if none of the joined columns has index
如果连接列上不存在索引,那么优化器将选择动态哈希连接。 - Join plan directives that force optimizer to use the designated join method to join tables in the query , either nested loop join , sort merge join , or dynamic hash join
连接计划指示,强制优化器使用指定的连接方法来连接查询中的表,要么是嵌套循环连接、分类合并连接,要么是动态哈希连接。 - In the previous example , if customer . customer num and orders . customer num are not indexed , dynamic hash join would be chosen by the optimizer as the best execution plan . the optimizer will choose nested - loop joins if
在前一个实例中,如果customer . customer _ num和orders . customer _ num都没有被索引,那么优化器将选择动态哈希连接来作为最佳的执行计划。